Act_Report (Visualization)¶

The following visualization graghs explains the insights gotten from the analysis of the WeRateDogs tweets archive data which consists of the following dataframes:

  • the twitter archive data (twitter_data)
  • the image prediction data
  • the df_tweets dataframe

These dataframes were mwrged into a dataset called the twitter_archive_master dataset, which was analysed to answer the following questions:

  1. what year and month did the highest tweets occur?
  2. what date recorded the highest favorite tweet?
  3. what are the predicted dog with the highest favorite count?
  4. What dog stage had the highest favorite counts?
  5. Is there any relationship between the favorite_count and retweet_count?

Using the visualizations below, the above questions are answered as follows:

1. what year and month did the highest tweets occur?¶

image.png

Answer: The highest tweets occured between the November 2015 to January 2016 and decreased across 2017

2. what date recorded the highest favorite tweet?¶

image.png

Answer:The highest favorite tweets occured on the 21st of january 2017 (2017-01-21 18:26:02+00:00)

3. what are the predicted dog with the highest favorite count?¶

image.png

Answer: The top three predicted dogs with the highest favorite counts include:

  • Lakeland_terrier
  • Labrador_retriever
  • English_springer

The Lakeland_terrier dog is shown in the image below with the highest likes(favorite_count) of 132810

Screenshot%20%2812%29.png

...

The Labrador_retriever dog is shown in the image below with the second highest likes(favorite_count) of 131075

Screenshot%20%2813%29.png

...

The image below is shows the English_springer dog having the third highest likes (favorite_count) of 107956

Screenshot%20%2814%29.png

4. What dog stage had the highest favorite counts?¶

image.png

Answer: Puppo is the dog stage with the highest favorite count

5. Is there any relationship between the favorite_count and retweet_count?¶

image.png

Answer: There is a positive correlation between the favorite_count and retweet count, meaning that there is an increase in the favorite_count corresponding to an increase in the retweet count.

6. Is there any relationship between the favorite_count and timestamp?¶

image.png

Answer: There is a positive correlation between the timestamp and the favorite_count which means that there was an increase in favorite count over time.

Insights¶

From the information obtained in our analysis, the following conclusions can be gathered:¶

  1. The highest tweets occured between the November 2015 to January 2016 and decreased across 2017

  2. The highest favorite tweets occured on the 21st of january 2017 (2017-01-21 18:26:02+00:00)

  3. The top three predicted dogs with the highest favorite counts include:

  • Lakeland_terrier
  • Labrador_retriever
  • English_springer
  1. Puppo is the dog stage with the highest favorite count.

  2. There is a positive correlation between the favorite_count and retweet count, meaning that there is an increase in the favorite_count corresponding to an increase in the retweet count.

  3. There is a positive correlation between the timestamp and the favorite_count which means that there was an increase in favorite count over time

In [ ]: